For example you can specify a maximum for the number of columns that can be part of an index key and change the Creator ID that is used when index DDL is generated. 例如,您可以指定作为索引键的一部分的列的最大数,还可以更改生成DDL时所使用的CreatorID。
For an index key column that is of variable length 具有可变长度的索引键列
But be careful with this tactic; you do not want to replicate a table in an index by including all of the table's columns in the index key. 但是要小心使用这一策略;您并不想以在索引键中包含数据表所有列的方式在索引中复制一个表。
Put another way, matching starts at the far left of the index key and proceeds rightward. 换句话说,匹配从索引键的最左端开始并向右匹配。
It should be noted that the DB2 index key size limit is1024 bytes, and the index key limit includes all overhead bytes. 应该注意,DB2索引键的大小限制为1024字节,而且索引键限制包括占用的所有字节。
IDS now automatically collects index statistics on the leading index key while the index is being created. IDS现在可以在索引创建时自动收集起始索引健上的索引统计信息。
The index key size limit also applies to those constraints that are enforced through indexes. 索引键大小限制也应用于通过索引施加的那些约束。
When each functional index is created, its associated UDR is executed to pre-process the images and store the results as the index key. 在创建函数索引时,将执行与其相关的UDR来对图像进行预处理,并将结果作为索引键保存。
A notable exception to this rule is unique indexes where the index key columns do not include the table partitioning key. 此规则的一个明显例外是,索引键列不包含表分区键的独立索引。
Based on the optimizer's estimate, there are eight qualifying RIDs within the target index key range. 基于优化器的估计,在目标索引键范围内有8个合格的RID。
When you create indexes on VARCHAR or VARGRAPHIC columns in your Unicode tables, you need to pay attention of the index key limit. 在Unicode表中的VARCHAR或VARGRAPHIC列上创建索引时,需要注意索引键限制。
Moreover, the ratio between the number of records and the number of index keys indicates, on average, the number of RIDs associated with each index key. 而且,记录的数量与索引键之间的比例说明,通常,RID的数量与每个索引键都有关联。
Getting a match on the column in position n+ 1 in the index key requires matching on the column in position n with an equal-type predicate or an in-list predicate. 在索引键中的位置n+1处获取一个匹配要求使用一个等于谓词或一个列表谓词匹配位置为n的列。
The load and create index operations always use private sorts for index key sorting, regardless of the value of the INTRA_PARALLEL parameter. 装入和创建索引的操作通常使用私有排序进行索引键的排序,无论INTRAPARALLEL参数的值如何。
Key generator function to construct index key during INSERT and UPDATE operations. 用于在INSERT和UPDATE操作中构造索引键的键生成器函数。
The index key limit might be reduced when you are using VARCHAR or VARGRAPHIC data type. 当使用VARCHAR或VARGRAPHIC数据类型时,索引键限制可能减少。
The generated hash value is numeric, and I use this value as single index key for the string being indexed. 生成的hash值是数值型的,我使用这个值作为被索引的字符串的索引键。
We can use randomized index key columns to reduce contention, but at what cost? 我们可以使用随机化的索引键列来减少争用,但这有何代价呢?
Also in the query rewrite vein, modifying a SELECT to get rid of a range-type predicate can increase performance by improving index key column matching. 另外,在查询重写状态下,修改SELECT来摆脱一个范围型谓词,可以通过提高索引键列匹配增强性能。
Damage alarming index is key in the bridge alarming system, whose working energy is decided by the effective of damage alarming. 损伤预警指标是桥梁预警系统研究中的关键内容,损伤预警的效果决定着整个系统的工作性能。
Cannot use duplicate column names in index key list. Column name '%. ls' listed more than once. 不能在索引键列表中使用重复名称。列名''%1!''多次列出。
Null value is not allowed in unique index or primary key. 唯一性索引或主键中不允许有空值。
Choice Selecting correct stock index is key to successful stock index futures. 选择合适的标的指数是股指期货合约成功与否的关键。
The stimulation results show that the modified RED algorithm can improve the forwarding ratio of the network node and the delay index of key operation, and has better performance in congestion control compared with RED algorithm. 仿真试验结果表明,改进RED算法可以提高网络节点的成功转发率,改善关键业务的延迟指标,具有更好的拥塞控制性能。
Discussion on Penetration Index as Key Quality Gradation Index of Paving Asphalt 针入度指数作为沥青质量分级指标的利弊
Second, studying into the theories aroundingdatabase-encryption system, explaining the cryptograph index, key management and some other key technologies in detail; 接着深入研究了数据库加密系统的相关理论,对密文索引、密钥管理等数据加密系统中的关键技术给出了详细的阐述;
This article mainly introduces the composition, major index, key technique of ETCS and forecasts the application of this system to our country. 本文主要介绍电子遥控软禁系统的构成、主要指标、关键技术,并对该系统在我国的应用等进行了展望。
New Evaluation Index for Key Technology Level of Damper 减振器关键工艺水平评价新指标
So it becomes increasingly important that efficient query in the enormous spatial data, creating appropriate spatial index is key to the efficient query. 因此在庞大的空间数据中高效的查询也变得越来越重要。所以为数据建立一个好空间索引,是高效查询的关键。